/*
Navicat SQL Server Data Transfer

Source Server         : xueyebing_oa
Source Server Version : 105000
Source Host           : 10.1.10.194:1433
Source Database       : ecology
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2017-06-12 13:53:14
*/


-- ----------------------------
-- Table structure for updateKtExpenseLog
-- ----------------------------
DROP TABLE [dbo].[updateKtExpenseLog]
GO
CREATE TABLE [dbo].[updateKtExpenseLog] (
[id] int NOT NULL IDENTITY(1,1) ,
[requestId] int NULL ,
[cprojectKind] varchar(999) NULL ,
[citem_name] varchar(999) NULL ,
[cProjectcode] varchar(999) NULL ,
[cprojectname] varchar(999) NULL ,
[citemcode] varchar(999) NULL ,
[citemname] varchar(999) NULL ,
[cSourceCode] varchar(999) NULL ,
[sSourceName] varchar(999) NULL ,
[dinSAmount] varchar(999) NULL ,
[dkje] varchar(999) NULL ,
[formmodeid] int NULL ,
[modedatacreater] int NULL ,
[modedatacreatertype] int NULL ,
[modedatacreatedate] varchar(10) NULL ,
[modedatacreatetime] varchar(8) NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[updateKtExpenseLog]', RESEED, 8385)
GO

-- ----------------------------
-- Indexes structure for table updateKtExpenseLog
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table updateKtExpenseLog
-- ----------------------------
ALTER TABLE [dbo].[updateKtExpenseLog] ADD PRIMARY KEY ([id])
GO
